<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>

<script type="text/javascript" src="../../com.atilax.frmwk/jquery-1.8.3.min.js"></script>
<script type="text/javascript" src="cfg.js"></script>
<script type="text/javascript" src="js/js_ui.js"></script>
<script type="text/javascript" src="../com.attilax/core/approot_js.jsp"></script>
<script type="text/javascript" src="../../com.attilax/core/core.js"></script>
<script type="text/javascript" src="../com.attilax/time/time.js"></script>
 <script type="text/javascript" src="../com.attilax/templete/jquery.tmpl.js"></script>
 
  <script type="text/javascript" src="../../com.attilax/core/core.js"></script>
    <script type="text/javascript" src="../com.attilax/HRE.js"></script>
    <script type="text/javascript" src="cfg.js"></script>
    <script type="text/javascript" src="../../com.attilax/net/req.js"></script>
    
    
</head>

<body><script type="text/javascript" src="filterParser.js"></script>


<script defer="defer">

function loadx()
{

	try{
		var exps_jsonstr=[{"fld":"user_id","op":"=","val":"123"},{"fld":"user_name","op":"=","val":"att2"}];
		//var os=JSON.stringify(o);
		var col_def_s=$("#colsDiv").val();
		//var col_def_o=str2json(col_def_s);
		
		var exp_sql_fmt= getWhereExpressPart4sql(exps_jsonstr,col_def_s);
		alert(exp_sql_fmt);
	}catch(e)
	{
		alert(e);
	}
}

</script>


<textarea name="colsDiv" id="colsDiv" cols="45" rows="5">[
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "用户id",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 8,
    "TYPE_NAME": "MEDIUMINT UNSIGNED",
    "IS_AUTOINCREMENT": "YES",
    "COLUMN_NAME": "user_id",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 1,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": 4
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 65535,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 65535,
    "TYPE_NAME": "TEXT",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "aite_id",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 2,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": -1
  },
    {
    "COLUMN_DEF": "",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 60,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "邮件",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 60,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "email",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 3,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": "",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 60,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 60,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "user_name",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 4,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": "",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 32,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 32,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "password",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 5,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": "",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 255,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 255,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "question",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 6,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": "",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 255,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 255,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "answer",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 7,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": null,
    "TYPE_NAME": "BIT",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "sex",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 8,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": -7
  },
    {
    "COLUMN_DEF": "0000-00-00",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "DATE",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "birthday",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 9,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 91
  },
    {
    "COLUMN_DEF": "0.00",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "DECIMAL",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "user_money",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 10,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 2,
    "DATA_TYPE": 3
  },
    {
    "COLUMN_DEF": "0.00",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "DECIMAL",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "frozen_money",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 11,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 2,
    "DATA_TYPE": 3
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "INT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "pay_points",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 12,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": 4
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "INT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "rank_points",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 13,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": 4
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 8,
    "TYPE_NAME": "MEDIUMINT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "address_id",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 14,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": 4
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "INT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "reg_time",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 15,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": 4
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "INT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "last_login",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 16,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": 4
  },
    {
    "COLUMN_DEF": "0000-00-00 00:00:00",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 19,
    "TYPE_NAME": "DATETIME",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "last_time",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 17,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 93
  },
    {
    "COLUMN_DEF": "",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 15,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 15,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "last_ip",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 18,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 5,
    "TYPE_NAME": "SMALLINT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "visit_count",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 19,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": 5
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 3,
    "TYPE_NAME": "TINYINT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "user_rank",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 20,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": -6
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 3,
    "TYPE_NAME": "TINYINT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "is_special",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 21,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": -6
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 10,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 1,
    "IS_NULLABLE": "YES",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "ec_salt",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 22,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 10,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "salt",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 23,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 7,
    "TYPE_NAME": "MEDIUMINT",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "parent_id",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 24,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": 4
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 3,
    "TYPE_NAME": "TINYINT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "flag",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 25,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": -6
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 60,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 60,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "alias",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 26,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 60,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 60,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "msn",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 27,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 20,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 20,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "qq",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 28,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 20,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 20,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "office_phone",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 29,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 20,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 20,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "home_phone",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 30,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 20,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 20,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "mobile_phone",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 31,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": "0",
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 3,
    "TYPE_NAME": "TINYINT UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "is_validated",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 32,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 0,
    "DATA_TYPE": -6
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": null,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 10,
    "TYPE_NAME": "DECIMAL UNSIGNED",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "credit_line",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 33,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": 2,
    "DATA_TYPE": 3
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 50,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 1,
    "IS_NULLABLE": "YES",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 50,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "passwd_question",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 34,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 255,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 1,
    "IS_NULLABLE": "YES",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 255,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "passwd_answer",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 35,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 28,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 28,
    "TYPE_NAME": "CHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "wxid",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 36,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 1
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 2,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 2,
    "TYPE_NAME": "CHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "wxch_bd",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 37,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 1
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 255,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 1,
    "IS_NULLABLE": "YES",
    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 255,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "nicheng",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 38,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  },
    {
    "COLUMN_DEF": null,
    "TABLE_NAME": "ecs_users",
    "CHAR_OCTET_LENGTH": 40,
    "SQL_DATETIME_SUB": 0,
    "REMARKS": "",
    "SCOPE_SCHEMA": null,
    "TABLE_SCHEM": null,
    "BUFFER_LENGTH": 65535,
    "NULLABLE": 0,
    "IS_NULLABLE": "NO",

    "SQL_DATA_TYPE": 0,
    "TABLE_CAT": "wxmiqi",
    "NUM_PREC_RADIX": 10,
    "COLUMN_SIZE": 40,
    "TYPE_NAME": "VARCHAR",
    "IS_AUTOINCREMENT": "NO",
    "COLUMN_NAME": "password_tianxin",
    "SCOPE_CATALOG": null,
    "ORDINAL_POSITION": 39,
    "SCOPE_TABLE": null,
    "SOURCE_DATA_TYPE": null,
    "DECIMAL_DIGITS": null,
    "DATA_TYPE": 12
  }
]</textarea>

<script defer="defer">

 loadx();
 </script>
 
</body>
</html>

